/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package sistemabienes;

import com.sun.data.provider.impl.CachedRowSetDataProvider;
import com.sun.rave.web.ui.appbase.AbstractPageBean;
import com.sun.webui.jsf.component.Button;
import com.sun.webui.jsf.component.Calendar;
import com.sun.webui.jsf.component.Hyperlink;
import com.sun.webui.jsf.component.Table;
import com.sun.webui.jsf.component.TableRowGroup;
import com.sun.webui.jsf.component.TextField;
import com.sun.webui.jsf.model.DefaultOptionsList;
import com.sun.webui.jsf.model.DefaultTableDataProvider;
import com.sun.webui.jsf.model.SingleSelectOptionsList;
import java.sql.SQLException;
import javax.faces.FacesException;
import claseactivos.DatosAsignacion;
import com.sun.data.provider.DataProviderException;
import com.sun.data.provider.RowKey;
import com.sun.sql.rowset.CachedRowSetXImpl;
import java.io.IOException;
import java.sql.CallableStatement;
import java.sql.ResultSet;
import java.text.ParseException;
import java.util.Date;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.faces.event.ValueChangeEvent;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
import javax.sql.rowset.spi.SyncProviderException;
/**
 * <p>Page bean that corresponds to a similarly named JSP page.  This
 * class contains component definitions (and initialization code) for
 * all components that you have defined on this page, as well as
 * lifecycle methods and event handlers where you may add behavior
 * to respond to incoming events.</p>
 *
 * @version asignacion.java
 * @version Created on 21-11-2011, 06:19:24 PM
 * @author luis
 */

public class asignacion extends AbstractPageBean {
    // <editor-fold defaultstate="collapsed" desc="Managed Component Definition">

    /**
     * <p>Automatically managed component initialization.  <strong>WARNING:</strong>
     * This method is automatically generated, so any user-specified code inserted
     * here is subject to being replaced.</p>
     */
    private void _init() throws Exception {
        activoDataProvider.setCachedRowSet((javax.sql.rowset.CachedRowSet) getValue("#{SessionBean1.activoRowSet}"));
        empleadosDataProvider.setCachedRowSet((javax.sql.rowset.CachedRowSet) getValue("#{SessionBean1.empleadosRowSet1}"));
        asignacionDataProvider.setCachedRowSet((javax.sql.rowset.CachedRowSet) getValue("#{SessionBean1.asignacionRowSet}"));
       // empleadosDataProvider.setCachedRowSet((javax.sql.rowset.CachedRowSet) getValue("#{SessionBean1.empleadosRowSet}"));
        txtEmpleadoCI.setValue(null);
        asignacionDataProvider1.setCachedRowSet((javax.sql.rowset.CachedRowSet) getValue("#{SessionBean1.asignacionBuscarRowSet}"));
    }
    
    private CachedRowSetDataProvider activoDataProvider = new CachedRowSetDataProvider();

    public CachedRowSetDataProvider getActivoDataProvider() {
        return activoDataProvider;
    }

    public void setActivoDataProvider(CachedRowSetDataProvider crsdp) {
        this.activoDataProvider = crsdp;
    }
    private TextField txtEmpleadoCI = new TextField();

    public TextField getTxtEmpleadoCI() {
        return txtEmpleadoCI;
    }

    public void setTxtEmpleadoCI(TextField tf) {
        this.txtEmpleadoCI = tf;
    }
    private TableRowGroup tableRowGroup1 = new TableRowGroup();

    public TableRowGroup getTableRowGroup1() {
        return tableRowGroup1;
    }

    public void setTableRowGroup1(TableRowGroup trg) {
        this.tableRowGroup1 = trg;
    }
    private TableRowGroup tableRowGroup2 = new TableRowGroup();

    public TableRowGroup getTableRowGroup2() {
        return tableRowGroup2;
    }

    public void setTableRowGroup2(TableRowGroup trg) {
        this.tableRowGroup2 = trg;
    }
    private CachedRowSetDataProvider empleadosDataProvider = new CachedRowSetDataProvider();

    public CachedRowSetDataProvider getEmpleadosDataProvider() {
        return empleadosDataProvider;
    }

    public void setEmpleadosDataProvider(CachedRowSetDataProvider crsdp) {
        this.empleadosDataProvider = crsdp;
    }
    private Table table2 = new Table();

    public Table getTable2() {
        return table2;
    }

    public void setTable2(Table t) {
        this.table2 = t;
    }
    private Table table1 = new Table();

    public Table getTable1() {
        return table1;
    }

    public void setTable1(Table t) {
        this.table1 = t;
    }
    private Hyperlink linkReporte = new Hyperlink();

    public Hyperlink getLinkReporte() {
        return linkReporte;
    }

    public void setLinkReporte(Hyperlink h) {
        this.linkReporte = h;
    }
    private Button btnGuardar = new Button();

    public Button getBtnGuardar() {
        return btnGuardar;
    }

    public void setBtnGuardar(Button b) {
        this.btnGuardar = b;
    }
    private TextField txtNombre = new TextField();

    public TextField getTxtNombre() {
        return txtNombre;
    }

    public void setTxtNombre(TextField tf) {
        this.txtNombre = tf;
    }
    private TextField txtDocIde = new TextField();

    public TextField getTxtDocIde() {
        return txtDocIde;
    }

    public void setTxtDocIde(TextField tf) {
        this.txtDocIde = tf;
    }
    private TextField txtApe = new TextField();

    public TextField getTxtApe() {
        return txtApe;
    }

    public void setTxtApe(TextField tf) {
        this.txtApe = tf;
    }
    private TextField txtCargo = new TextField();

    public TextField getTxtCargo() {
        return txtCargo;
    }

    public void setTxtCargo(TextField tf) {
        this.txtCargo = tf;
    }
    private TextField txtInst = new TextField();

    public TextField getTxtInst() {
        return txtInst;
    }

    public void setTxtInst(TextField tf) {
        this.txtInst = tf;
    }
    private CachedRowSetDataProvider asignacionDataProvider = new CachedRowSetDataProvider();

    public CachedRowSetDataProvider getAsignacionDataProvider() {
        return asignacionDataProvider;
    }

    public void setAsignacionDataProvider(CachedRowSetDataProvider crsdp) {
        this.asignacionDataProvider = crsdp;
    }
    private CachedRowSetDataProvider asignacionDataProvider1 = new CachedRowSetDataProvider();

    public CachedRowSetDataProvider getAsignacionDataProvider1() {
        return asignacionDataProvider1;
    }

    public void setAsignacionDataProvider1(CachedRowSetDataProvider crsdp) {
        this.asignacionDataProvider1 = crsdp;
    }
    private TextField txtBuscarCI = new TextField();

    public TextField getTxtBuscarCI() {
        return txtBuscarCI;
    }

    public void setTxtBuscarCI(TextField tf) {
        this.txtBuscarCI = tf;
    }
    private Calendar txtFechaB = new Calendar();

    public Calendar getTxtFechaB() {
        return txtFechaB;
    }

    public void setTxtFechaB(Calendar c) {
        this.txtFechaB = c;
    }
    private TextField txtBuscaCod = new TextField();

    public TextField getTxtBuscaCod() {
        return txtBuscaCod;
    }

    public void setTxtBuscaCod(TextField tf) {
        this.txtBuscaCod = tf;
    }

    

    // </editor-fold>

    /**
     * <p>Construct a new Page bean instance.</p>
     */
    public asignacion() {
    }

    /**
     * <p>Callback method that is called whenever a page is navigated to,
     * either directly via a URL, or indirectly via page navigation.
     * Customize this method to acquire resources that will be needed
     * for event handlers and lifecycle methods, whether or not this
     * page is performing post back processing.</p>
     * 
     * <p>Note that, if the current request is a postback, the property
     * values of the components do <strong>not</strong> represent any
     * values submitted with this request.  Instead, they represent the
     * property values that were saved for this view when it was rendered.</p>
     */
    @Override
    public void init() {
        // Perform initializations inherited from our superclass
        super.init();
        // Perform application initialization that must complete
        // *before* managed components are initialized
        // TODO - add your own initialiation code here

        txtEmpleadoCI.setValue(null);
        asignacionDataProvider.refresh();
        // <editor-fold defaultstate="collapsed" desc="Managed Component Initialization">
        // Initialize automatically managed components
        // *Note* - this logic should NOT be modified
        try {
            _init();
        } catch (Exception e) {
            log("asignacion Initialization Failure", e);
            throw e instanceof FacesException ? (FacesException) e: new FacesException(e);
        }
        
        // </editor-fold>
        // Perform application initialization that must complete
        // *after* managed components are initialized
        // TODO - add your own initialization code here
    }

    /**
     * <p>Callback method that is called after the component tree has been
     * restored, but before any event processing takes place.  This method
     * will <strong>only</strong> be called on a postback request that
     * is processing a form submit.  Customize this method to allocate
     * resources that will be required in your event handlers.</p>
     */
    @Override
    public void preprocess() {
    }

    /**
     * <p>Callback method that is called just before rendering takes place.
     * This method will <strong>only</strong> be called for the page that
     * will actually be rendered (and not, for example, on a page that
     * handled a postback and then navigated to a different page).  Customize
     * this method to allocate resources that will be required for rendering
     * this page.</p>
     */
    @Override
    public void prerender() {
       /* try {
          //  this.getSessionBean1().getActivoRowSet().setCommand("SELECT * FROM ACTIVOS.ACTIVO where estado_baja=1");
            //this.getSessionBean1().getActivoRowSet().execute();
            /*if (txtEmpleadoCI.getText() == null || txtEmpleadoCI.getText().toString().length() == 0) {
            table1.setVisible(false);
            table2.setVisible(false);
            btnGuardar.setDisabled(true);
            linkReporte.setDisabled(true);
            try {
            getSessionBean1().getEmpleadosRowSet1().setObject(1, "");
            } catch (SQLException ex) {
            Logger.getLogger(Page1.class.getName()).log(Level.SEVERE, null, ex);
            }
            }
        } catch (SQLException ex) {
            Logger.getLogger(asignacion.class.getName()).log(Level.SEVERE, null, ex);
        }*/
        /*if (txtEmpleadoCI.getText() == null || txtEmpleadoCI.getText().toString().length() == 0) {
            table1.setVisible(false);
            table2.setVisible(false);
            btnGuardar.setDisabled(true);
              linkReporte.setDisabled(true);
        try {

            getSessionBean1().getEmpleadosRowSet1().setObject(1, "");

                } catch (SQLException ex) {

                Logger.getLogger(Page1.class.getName()).log(Level.SEVERE, null, ex);

                }
        }*/
     asignacionDataProvider.refresh();
    }

    /**
     * <p>Callback method that is called after rendering is completed for
     * this request, if <code>init()</code> was called (regardless of whether
     * or not this was the page that was actually rendered).  Customize this
     * method to release resources acquired in the <code>init()</code>,
     * <code>preprocess()</code>, or <code>prerender()</code> methods (or
     * acquired during execution of an event handler).</p>
     */
    @Override
    public void destroy() {
        
        activoDataProvider.close();
        empleadosDataProvider.close();
        asignacionDataProvider.close();
        asignacionDataProvider1.close();
    }
  protected SessionBean1 getSessionBean1() {
        return (SessionBean1) getBean("SessionBean1");
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected RequestBean1 getRequestBean1() {
        return (RequestBean1) getBean("RequestBean1");
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected ApplicationBean1 getApplicationBean1() {
        return (ApplicationBean1) getBean("ApplicationBean1");
    }
    public String button2_action() throws SQLException {
        // TODO: Process the action. Return value is a navigation
        // case name where null will return to the same page.

        CachedRowSetXImpl asignacionRowSet = getSessionBean1().getAsignacionRowSet();
        int keyasig=1;
        RowKey rk = getTableRowGroup1().getRowKey();
        String bandera="0";
//        this.activoDataProvider.cursorFirst();
              String bandeja = this.activoDataProvider.getValue("EST_BANDEJA", rk).toString();
      if(bandera.equals(bandeja) || bandeja==null ){

        int keys= Integer.parseInt(this.activoDataProvider.getValue("KEYSECCION", rk).toString());
       // int keyp =Integer.parseInt(this.activoDataProvider.getValue("KEYPERSONA", rk).toString());
        int keyp=432;
        int keyb =Integer.parseInt( this.activoDataProvider.getValue("KEYBIEN", rk).toString());
         String codb=this.activoDataProvider.getValue("COD_BIEN", rk).toString();
         String desc=this.activoDataProvider.getValue("DESCRIPCION", rk).toString();

         String[] parametros= {"cod_bien"};
         Object[] valores= {codb};
         int b=1;
         this.activoDataProvider.setCursorRow(rk);
         if(getSessionBean1().getAsignacionDataProviver().getRowCount()!=0)
         {          getSessionBean1().getAsignacionDataProviver().cursorFirst();
                     RowKey fila= this.getSessionBean1().getAsignacionDataProviver().findFirst(parametros, valores);
                  if(fila==null)
                 {
                      try{
                 //Crear nuevos datos
                    DatosAsignacion datos = new DatosAsignacion(keyasig,keys,keyp,keyb,codb,desc);
                //Agregar registros al DataProvider
                    getSessionBean1().getAsignacionDataProviver().addNames(datos);
                    getSessionBean1().getAsignacionDataProviver().commitChanges();
                    System.out.println("Registro add");
                    //this.activoDataProvider.setValue("EST_BANDEJA",b);
                    //this.getSessionBean1().getActivoRowSet().setCommand("SELECT * FROM ACTIVOS.ACTIVO where estado_baja=1");
                  //  this.getSessionBean1().getActivoRowSet().execute();
                    this.getSessionBean1().getActivoRowSet().acceptChanges();
                    //this.activoDataProvider.commitChanges();
                    //this.activoDataProvider.refresh();

                    } catch (SyncProviderException  ex) {
                        error(ex.getMessage());
                        error(ex.getStackTrace().toString());
                    }
                    
                 }
                 else {
                    error("elemento a asignar ya esta en la lista");
                 }
         }else
         {
             try{
                    //this.activoDataProvider.cursorFirst();
                    DatosAsignacion datos = new DatosAsignacion(keyasig,keys,keyp,keyb,codb,desc);
                //Agregar registros al DataProvider
                    getSessionBean1().getAsignacionDataProviver().addNames(datos);
                    getSessionBean1().getAsignacionDataProviver().commitChanges();
                    System.out.println("Registro add");

                  //  this.activoDataProvider.setValue("EST_BANDEJA", b);
                    //this.getSessionBean1().getActivoRowSet().setCommand("SELECT * FROM ACTIVOS.ACTIVO where estado_baja=1");
                    this.getSessionBean1().getActivoRowSet().acceptChanges();
                    
                    //this.activoDataProvider.commitChanges();
                   // this.activoDataProvider.refresh();
                    
                   } catch (SyncProviderException  ex) {
                            error(ex.getMessage());
                            error(ex.getStackTrace().toString());
                        }
             //this.activoDataProvider.commitChanges();
         }
    }else{ error("El activo ya esta en bandeja por otro usuario");}

             // this.activoDataProvider.refresh();
              return null;
    }

    public void borrar_action() {
        // TODO: Process the action. Return value is a navigation
        // case name where null will return to the same page.
     //int b=0;
      RowKey rk = getTableRowGroup2().getRowKey();
      String codb=getSessionBean1().getAsignacionDataProviver().getValue("cod_bien",rk).toString();
      /*String[] parametros= {"cod_bien"};
      Object[] valores= {codb};
      RowKey filaAsig=this.activoDataProvider.findFirst(parametros, valores);
      if(filaAsig!=null){
            this.activoDataProvider.setValue("EST_BANDEJA", filaAsig,b);
            this.activoDataProvider.commitChanges();
         }*/
    getSessionBean1().getAsignacionDataProviver().removeObject(rk);
    getSessionBean1().getAsignacionDataProviver().commitChanges();
 
        //return  null;
    }

    public void txtEmpleadoCI_processValueChange(ValueChangeEvent event) throws SQLException {
       /* if (txtEmpleadoCI.getText().toString() != null || txtEmpleadoCI.getText().toString().length() > 0) {

            table1.setVisible(true);
            table2.setVisible(true);
            btnGuardar.setDisabled(false);
              linkReporte.setDisabled(false);

            //listbox1.setVisible(true);
            //table1.setVisible(true);
            }

            String prefix = txtEmpleadoCI.getText().toString();

            String doctName = prefix.substring(0, 1).toUpperCase() + prefix.substring(1) + '%';
           // try {

                  //getSessionBean1().getEmpleadosRowSet1().setObject("CI", doctName);
                    RowKey fila=empleadosDataProvider.findFirst("CI",doctName);
                    if(fila==null){
                            error("No se encontro al empleado");
                    }else
                    {
                           String ci=empleadosDataProvider.getValue("CI", fila).toString();
                           String nom=empleadosDataProvider.getValue("NOMBRE", fila).toString();
                           String pat=empleadosDataProvider.getValue("PATERNO", fila).toString();
                           String mat=empleadosDataProvider.getValue("MATERNO", fila).toString();
                           String uni=empleadosDataProvider.getValue("UNIDAD", fila).toString();
                           String carg=empleadosDataProvider.getValue("CARGO", fila).toString();
                           txtDocIde.setText(ci);
                           txtNombre.setText(nom);
                           txtApe.setText(pat+mat);
                           txtInst.setText(uni);
                           txtCargo.setText(carg);
                    }
                  //empleadosDataProvider.getValue(fieldKey, row);
                       empleadosDataProvider.refresh();

                     } catch (SQLException ex) {

                    Logger.getLogger(Page1.class.getName()).log(Level.SEVERE, null, ex);

                    }*/

    }

    public String btnBuscar_action() throws NamingException {
        // TODO: Process the action. Return value is a navigation
        // case name where null will return to the same page.
        if (!txtEmpleadoCI.getText().toString().equals("-") || txtEmpleadoCI.getText().toString().length() > 0) {

            table1.setVisible(true);
            table2.setVisible(true);
            btnGuardar.setDisabled(false);
              linkReporte.setDisabled(false);

            //listbox1.setVisible(true);
            //table1.setVisible(true);
              String prefix = txtEmpleadoCI.getText().toString();

            String doctName = '%'+prefix.substring(0, 1).toUpperCase() + prefix.substring(1) + '%';
              try{
                String dataSourceName=
                        this.getSessionBean1().getEmpleadosRowSet1().getDataSourceName();
                 Context ctx= new InitialContext();
                 DataSource ds=(DataSource) ctx.lookup(dataSourceName);

                 CallableStatement cs1 = ds.getConnection().prepareCall("SELECT emp.KEYEMPLEADO,emp.NOMBRE,emp.PATERNO,emp.MATERNO,emp.CI,uni.UNIDAD,ca.CARGO FROM EMPLEADOS emp,CONTROLINTERNO cin,UNIDADES uni,CARGOS ca WHERE emp.KEYEMPLEADO = cin.KEYEMPLEADO AND cin.KEYCARGO= ca.KEYCARGO AND uni.KEYUNIDAD= cin.KEYUNIDAD and cin.fechaconclusion is null and emp.CI=?");
                   cs1.setString(1,prefix);
                 ResultSet rs=cs1.executeQuery();
                 //ext())
                 if(rs.next()){
                     String ci=rs.getString("CI").toString();
                     String nom=rs.getString("NOMBRE").toString();
                     String pat=rs.getString("PATERNO").toString();
                     String mat=rs.getString("MATERNO").toString();
                     String uni=rs.getString("UNIDAD").toString();
                     String carg=rs.getString("CARGO").toString();

                           txtDocIde.setText(ci);
                           txtNombre.setText(nom);
                           txtApe.setText(pat+" "+mat);
                           txtInst.setText(uni);
                           txtCargo.setText(carg);
                 }
                 //while(rs.next());
                  /* do
                   {

                   }while (rs.next());*/


     }catch(SQLException e)
            {
                error(e.getMessage());

            }
            }

/*
           // try {
                String[] parametros= {"CI"};
                    Object[] valores= {doctName};
                  //getSessionBean1().getEmpleadosRowSet1().setObject("CI", doctName);
                    RowKey fila=empleadosDataProvider.findFirst(parametros,valores);
                    if(fila==null){
                            error("No se encontro al empleado");
                    }else
                    {
                           String ci=empleadosDataProvider.getValue("CI", fila).toString();
                           String nom=empleadosDataProvider.getValue("NOMBRE", fila).toString();
                           String pat=empleadosDataProvider.getValue("PATERNO", fila).toString();
                           String mat=empleadosDataProvider.getValue("MATERNO", fila).toString();
                           String uni=empleadosDataProvider.getValue("UNIDAD", fila).toString();
                           String carg=empleadosDataProvider.getValue("CARGO", fila).toString();
                           txtDocIde.setText(ci);
                           txtNombre.setText(nom);
                           txtApe.setText(pat+mat);
                           txtInst.setText(uni);
                           txtCargo.setText(carg);
                    }
                  //empleadosDataProvider.getValue(fieldKey, row);
                       empleadosDataProvider.refresh();

                 /*    } catch (SQLException ex) {

                    Logger.getLogger(Page1.class.getName()).log(Level.SEVERE, null, ex);

                    }*/

        return null;
    }

    public boolean buscaPersona(String ci) throws NamingException, SQLException,ParseException,IOException
    {
        String[] parametros= {"cod_bien"};
         Object[] valores= {ci};
        RowKey fila=empleadosDataProvider.findFirst(parametros, valores);
        if(fila==null)
        {
            error("no se encontro empleado");
        }else
            {
                //String
             }
     return true;
    }

    public String btnCancelar_action() {
        // TODO: Process the action. Return value is a navigation
        // case name where null will return to the same page.
        txtEmpleadoCI.setValue(null);
        txtDocIde.setText(null);
       txtNombre.setText(null);
       txtApe.setText(null);
       txtInst.setText(null);
       txtCargo.setText(null);
        this.getSessionBean1().getAsignacionDataProviver().clearObjectList();
        return null;
    }

    public String btnGuardar_action() throws NamingException {
        // TODO: Process the action. Return value is a navigation
        // case name where null will return to the same page.

   if (txtEmpleadoCI.getText().toString() != null || txtEmpleadoCI.getText().toString().length() > 0) {
        if(getSessionBean1().getAsignacionDataProviver().getRowCount()!=0)
         {
              Date date = new Date();
                getSessionBean1().setFechaInicio((Date)date);

              String prefix = txtEmpleadoCI.getText().toString();
              getSessionBean1().getAsignacionDataProviver().cursorFirst();
                    this.asignacionDataProvider.cursorFirst();
                     //RowKey fila = getSessionBean1().getAsignacionDataProviver().getCursorRow();
                    int keyasign=1;
                    //int keyseccion=1;
                  if( this.asignacionDataProvider.getRowCount()==0)
                    {
                    do{
                        getSessionBean1().getAsignacionDataProviver().getValue("keybien");
                        //this.getSessionBean1().getAsignacionDataProviver().getValue("keypersona");
                        int keyseccion=Integer.parseInt(this.getSessionBean1().getAsignacionDataProviver().getValue("keyseccion").toString());
                        String codb=this.getSessionBean1().getAsignacionDataProviver().getValue("cod_bien").toString();
                        int keyb=Integer.parseInt(this.getSessionBean1().getAsignacionDataProviver().getValue("keybien").toString());
                        //////inserta a data provider
                        boolean s[] = {true, true, true,true,true,true,true,true};
                        RowKey row2=this.asignacionDataProvider.appendRow();
                        this.getSessionBean1().getAsignacionRowSet().setInsertableColumns(s);
                         this.asignacionDataProvider.setValue("key_asignacion",row2, keyasign);
                         this.asignacionDataProvider.setValue("keyseccion",row2, keyseccion);
                         this.asignacionDataProvider.setValue("keypersona",row2,prefix);
                         this.asignacionDataProvider.setValue("keybien",row2,keyb);
                         this.asignacionDataProvider.setValue("cod_bien",row2,codb);
                         cambiarEstadoActivo(codb);
                         this.asignacionDataProvider.setValue("estado",row2,1);
                         this.asignacionDataProvider.setValue("fecha_asig",row2,new java.sql.Date(date.getTime()));
                         this.asignacionDataProvider.setValue("doc_identidad",row2,prefix);
                         //keyasign++;
                    }while(getSessionBean1().getAsignacionDataProviver().cursorNext());
                    this.asignacionDataProvider.commitChanges();
                    this.asignacionDataProvider.refresh();
                    this.activoDataProvider.refresh();
                    //Resetea campos
                 /*  txtEmpleadoCI.setText(null);
                    txtDocIde.setText(null);
                   txtNombre.setText(null);
                   txtApe.setText(null);
                   txtInst.setText(null);
                   txtCargo.setText(null);*/
                    this.getSessionBean1().getAsignacionDataProviver().clearObjectList();
                    error("se inserto correctamente");
                  }else
                  {
                       int max=buscar_max_asignacion();
                        do{
                        this.getSessionBean1().getAsignacionDataProviver().getValue("keybien");
                        //this.getSessionBean1().getAsignacionDataProviver().getValue("keypersona");
                        int keyseccion=Integer.parseInt(this.getSessionBean1().getAsignacionDataProviver().getValue("keyseccion").toString());
                        String codb=this.getSessionBean1().getAsignacionDataProviver().getValue("cod_bien").toString();
                        int keyb=Integer.parseInt(this.getSessionBean1().getAsignacionDataProviver().getValue("keybien").toString());
                        //////inserta a data provider
                        boolean s[] = {true, true, true,true,true,true,true,true};
                        RowKey row2=this.asignacionDataProvider.appendRow();
                        this.getSessionBean1().getAsignacionRowSet().setInsertableColumns(s);
                         this.asignacionDataProvider.setValue("key_asignacion",row2, max);
                         this.asignacionDataProvider.setValue("keyseccion",row2, keyseccion);
                         this.asignacionDataProvider.setValue("keypersona",row2,prefix);
                         this.asignacionDataProvider.setValue("keybien",row2,keyb);
                         this.asignacionDataProvider.setValue("cod_bien",row2,codb);
                         cambiarEstadoActivo(codb);
                         this.asignacionDataProvider.setValue("estado",row2,1);
                         this.asignacionDataProvider.setValue("fecha_asig",row2,new java.sql.Date(date.getTime()));
                         this.asignacionDataProvider.setValue("doc_identidad",row2,prefix);
                         keyasign++;
                    }while(getSessionBean1().getAsignacionDataProviver().cursorNext());
                    this.asignacionDataProvider.commitChanges();
                    this.asignacionDataProvider.refresh();
                    this.activoDataProvider.refresh();
                    //Resetea campos
                   /* txtEmpleadoCI.setText(null);
                    txtDocIde.setText(null);
                   txtNombre.setText(null);
                   txtApe.setText(null);
                   txtInst.setText(null);
                   txtCargo.setText(null);*/
                    this.getSessionBean1().getAsignacionDataProviver().clearObjectList();

                    error("se inserto correctamente");
                  }

          }else
         {
            error("No hay elementos a asignar");
         }

    }else {error("no existe persona para asignar");}
        return null;
    }

    public int buscar_max_asignacion() throws NamingException
    {
        int secuencia=0;
            try{
                String dataSourceName=
                        this.getSessionBean1().getUsuarioRowSet2().getDataSourceName();
                 Context ctx= new InitialContext();
                 DataSource ds=(DataSource) ctx.lookup(dataSourceName);

                 CallableStatement cs1 = ds.getConnection().prepareCall("select max(key_asignacion) as secuencia from asignacion");
                   ResultSet rs=cs1.executeQuery();
                 if(rs.next())
                 {
                     int valor=rs.getInt(1);
                     secuencia=valor+1;
                     rs.close();
                      return secuencia;
                 }
                  /* do
                   {

                   }while (rs.next());*/


     }catch(SQLException e)
            {
                error(e.getMessage());

            }

        return 0;
    }
public void cambiarEstadoActivo(String cod) throws NamingException
    {
        int secuencia=0;
            try{
                String dataSourceName=
                        this.getSessionBean1().getActivoRowSet().getDataSourceName();
                 Context ctx= new InitialContext();
                 DataSource ds=(DataSource) ctx.lookup(dataSourceName);

                 CallableStatement cs1 = ds.getConnection().prepareCall("CALL activos.UPDATE_ASIG(?)");
                  cs1.setString(1,cod);
                 cs1.execute();
     }catch(SQLException e)
            {
                error(e.getMessage());

            }
    
    }

    public String button4_action() {
        // TODO: Process the action. Return value is a navigation
        // case name where null will return to the same page.
        if (txtBuscarCI.getText().toString() != null || txtBuscarCI.getText().toString().length() > 0) {
            try{
            String ci=txtBuscarCI.getText().toString();
            //this.getSessionBean1().asignacionBuscarRowSet.setCommand("select * from asignacion where ci=?");
            //this.getSessionBean1().asignacionRowSet.setCommand("update asignacion set estado=0 where ci=?");
            this.getSessionBean1().asignacionRowSet.setCommand("select keybien,cod_bien,estado,fecha_asig,doc_identidad from asignacion where doc_identidad like ?");
            this.getSessionBean1().asignacionRowSet.setString(1,ci);
            //this.getSessionBean1().asignacionRowSet.execute();
            //this.getSessionBean1().asignacionRowSet.commit();
            asignacionDataProvider.refresh();
            

                }catch(SQLException e)
            {
                error(e.getMessage());

            }
        }

        return null;
    }

    public String linkReporte_action() {
        // TODO: Process the action. Return value is a navigation
        // case name where null will return to the same page.
      String ci=  txtDocIde.getText().toString();
      String nombre=txtNombre.getText().toString()+" "+txtApe.getText().toString();
      String inst=txtInst.getText().toString();
      String unidad=txtCargo.getText().toString();
       this.getSessionBean1().setCi(ci);
       this.getSessionBean1().setNombre(nombre);
       this.getSessionBean1().setInst(inst);
       this.getSessionBean1().setUnidad(unidad);
        return "case1";
    }

    public String tab1_action() {
        // TODO: Process the action. Return value is a navigation
        // case name where null will return to the same page.
        return null;
    }

    public String tab2_action() {
        // TODO: Process the action. Return value is a navigation
        // case name where null will return to the same page.
        return null;
    }

    public String button1_action() throws SQLException {
        // TODO: Process the action. Return value is a navigation
        // case name where null will return to the same page.
       if(txtBuscaCod.getValue().toString().equals("-"))
       {
        //String cod= txtBuscaCod.getText().toString();
        this.getSessionBean1().getActivoRowSet().setCommand("SELECT * FROM ACTIVOS.ACTIVO where estado_baja=0 and estado_asignacion=0 order by fecha_ingreso desc");
          //  this.getSessionBean1().asignacionRowSet.setString(1,cod);
            //this.getSessionBean1().asignacionRowSet.execute();
            //this.getSessionBean1().asignacionRowSet.commit();
            activoDataProvider.refresh();
       }else
       {
        String cod= txtBuscaCod.getText().toString();
        this.getSessionBean1().getActivoRowSet().setCommand("SELECT * FROM ACTIVOS.ACTIVO where estado_baja=0 and estado_asignacion=0 and cod_bien like ? order by fecha_ingreso desc");
            this.getSessionBean1().getActivoRowSet().setString(1,cod);
            //this.getSessionBean1().asignacionRowSet.execute();
            //this.getSessionBean1().asignacionRowSet.commit();
            activoDataProvider.refresh();
            int i= activoDataProvider.getRowCount();
            int h=0;
         if(i==h)
         {
            this.getSessionBean1().getActivoRowSet().setCommand("SELECT * FROM ACTIVOS.ACTIVO where estado_baja=0 and estado_asignacion=0 and descripcion like ? order by fecha_ingreso desc");
            this.getSessionBean1().getActivoRowSet().setString(1,"%"+cod+"%");
            //this.getSessionBean1().asignacionRowSet.execute();
            //this.getSessionBean1().asignacionRowSet.commit();
            activoDataProvider.refresh();
         }
       }
        return null;
    }



}

